﻿<?xml version="1.0" encoding="utf-8" ?>

<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" namespace="MSH.Common.Business" assembly="Common">

<class name="MobileNumberRequest" table="MobileNumberRequest">

  <id name="ID">
    <generator class="native">
      <param name="sequence">SeqMobileNumberRequestID</param>
    </generator>
  </id>

  <property name="MobilePhoneNumber">
    <column name="MobilePhoneNumber" length="30" not-null="true"/>
  </property>

  <property name="Code">
    <column name="Code" length="30" not-null="false"  />
  </property>

  <property name="Requests">
    <column name="Requests" not-null="false"  />
  </property>

  <many-to-one name="User"
    column="ParentUser" cascade="none" fetch="join" not-null="true"/>

</class>

</hibernate-mapping>

